using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VICC_EKPOS
    {
        public DataRow Convert2ICC_EKPOS(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryICC_EKPOS(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["EKPAID"] = " ".PadRight(0 ); 
         dwReturn["EKKBUCHKRS"] = " ".PadRight(3 ); 
         dwReturn["EKPMANDANT"] = " ".PadRight(2 ); 
         dwReturn["EKPAUFKRS"] = " ".PadRight(2 ); 
         dwReturn["EKPAUFLFD"] = " ".PadRight(6 ); 
         dwReturn["EKPAUFPOS"] = " ".PadRight(3 ); 
         dwReturn["EKPQTYLOCKED"] = " ".PadRight(0 ); 
         dwReturn["EKPQTYFREE"] = " ".PadRight(0 ); 
         dwReturn["EKPAENDST"] = " ".PadRight(3 ); 
         dwReturn["EKPKNTRNRL"] = " ".PadRight(15 ); 
         dwReturn["EKPAENZL"] = " ".PadRight(0 ); 
         dwReturn["EKPAENB"] = " ".PadRight(8 ); 
         dwReturn["EKPAEND"] = " ".PadRight(0 ); 
         dwReturn["EKPBEKZ"] = " ".PadRight(1 ); 
         dwReturn["EKPNEUB"] = " ".PadRight(8 ); 
         dwReturn["EKPNEUD"] = " ".PadRight(0 ); 
         dwReturn["EKPAUFGRP"] = " ".PadRight(1 ); 
         dwReturn["EKPAUFART"] = " ".PadRight(2 ); 
         dwReturn["EKPARTGR"] = " ".PadRight(1 ); 
         dwReturn["EKPKUNDNR"] = " ".PadRight(8 ); 
         dwReturn["EKPWERK"] = " ".PadRight(3 ); 
         dwReturn["EKPABT"] = " ".PadRight(3 ); 
         dwReturn["EKPWAKZ"] = " ".PadRight(1 ); 
         dwReturn["EKPART"] = " ".PadRight(20 ); 
         dwReturn["EKPVAR"] = " ".PadRight(3 ); 
         dwReturn["EKPFARBE"] = " ".PadRight(10 ); 
         dwReturn["EKPDESS"] = " ".PadRight(10 ); 
         dwReturn["EKPCOL"] = " ".PadRight(10 ); 
         dwReturn["EKPBESCH"] = " ".PadRight(10 ); 
         dwReturn["EKPZUSTAND"] = " ".PadRight(4 ); 
         dwReturn["EKPGROE"] = " ".PadRight(7 ); 
         dwReturn["EKPSCHLIGR"] = " ".PadRight(5 ); 
         dwReturn["EKPSCHLINR"] = " ".PadRight(15 ); 
         dwReturn["EKPLSART"] = " ".PadRight(20 ); 
         dwReturn["EKPLSVAR"] = " ".PadRight(3 ); 
         dwReturn["EKPLSFB"] = " ".PadRight(10 ); 
         dwReturn["EKPLSDESS"] = " ".PadRight(10 ); 
         dwReturn["EKPLSCOL"] = " ".PadRight(10 ); 
         dwReturn["EKPLSBE"] = " ".PadRight(10 ); 
         dwReturn["EKPLSZUSTAND"] = " ".PadRight(4 ); 
         dwReturn["EKPLSGROE"] = " ".PadRight(7 ); 
         dwReturn["EKPLSGRPBEZ"] = " ".PadRight(20 ); 
         dwReturn["EKPLSARTBEZ"] = " ".PadRight(40 ); 
         dwReturn["EKPSTKLGV"] = " ".PadRight(0 ); 
         dwReturn["EKPSTKLGB"] = " ".PadRight(0 ); 
         dwReturn["EKPPRKZ"] = " ".PadRight(1 ); 
         dwReturn["EKPPRUEF"] = " ".PadRight(4 ); 
         dwReturn["EKPMATKOMPDR"] = " ".PadRight(1 ); 
         dwReturn["EKPPARTIE"] = " ".PadRight(7 ); 
         dwReturn["EKPSPUL"] = " ".PadRight(0 ); 
         dwReturn["EKPSPULG"] = " ".PadRight(0 ); 
         dwReturn["EKPSPULM"] = " ".PadRight(0 ); 
         dwReturn["EKPVPEINH"] = " ".PadRight(4 ); 
         dwReturn["EKPAM"] = " ".PadRight(2 ); 
         dwReturn["EKPZUSAM"] = " ".PadRight(2 ); 
         dwReturn["EKPHUELSE"] = " ".PadRight(6 ); 
         dwReturn["EKPKF"] = " ".PadRight(1 ); 
         dwReturn["EKPFDRES"] = " ".PadRight(1 ); 
         dwReturn["EKPWI"] = " ".PadRight(1 ); 
         dwReturn["EKPANZTKB"] = " ".PadRight(0 ); 
         dwReturn["EKPLOSGR"] = " ".PadRight(0 ); 
         dwReturn["EKPWIRKGEW"] = " ".PadRight(0 ); 
         dwReturn["EKPVKUNDNR"] = " ".PadRight(8 ); 
         dwReturn["EKPVWERK"] = " ".PadRight(3 ); 
         dwReturn["EKPVABT"] = " ".PadRight(3 ); 
         dwReturn["EKPVART"] = " ".PadRight(20 ); 
         dwReturn["EKPVVAR"] = " ".PadRight(3 ); 
         dwReturn["EKPVFARBE"] = " ".PadRight(10 ); 
         dwReturn["EKPEKUNDNR"] = " ".PadRight(8 ); 
         dwReturn["EKPEWERK"] = " ".PadRight(3 ); 
         dwReturn["EKPEABT"] = " ".PadRight(3 ); 
         dwReturn["EKPEART"] = " ".PadRight(20 ); 
         dwReturn["EKPEVAR"] = " ".PadRight(3 ); 
         dwReturn["EKPEFARBE"] = " ".PadRight(10 ); 
         dwReturn["EKPEDESS"] = " ".PadRight(10 ); 
         dwReturn["EKPECOL"] = " ".PadRight(10 ); 
         dwReturn["EKPEBESCH"] = " ".PadRight(10 ); 
         dwReturn["EKPEZUSTAND"] = " ".PadRight(4 ); 
         dwReturn["EKPEGROE"] = " ".PadRight(7 ); 
         dwReturn["EKPMINLIME"] = " ".PadRight(0 ); 
         dwReturn["EKPMINLISP"] = " ".PadRight(0 ); 
         dwReturn["EKPMEEH"] = " ".PadRight(3 ); 
         dwReturn["EKPMEEHGRP"] = " ".PadRight(1 ); 
         dwReturn["EKPMEEHFKT"] = " ".PadRight(12 ); 
         dwReturn["EKPME1"] = " ".PadRight(0 ); 
         dwReturn["EKPME2"] = " ".PadRight(0 ); 
         dwReturn["EKPME3"] = " ".PadRight(0 ); 
         dwReturn["EKPME4"] = " ".PadRight(0 ); 
         dwReturn["EKPME5"] = " ".PadRight(0 ); 
         dwReturn["EKPME6"] = " ".PadRight(0 ); 
         dwReturn["EKPME7"] = " ".PadRight(0 ); 
         dwReturn["EKPME8"] = " ".PadRight(0 ); 
         dwReturn["EKPME9"] = " ".PadRight(0 ); 
         dwReturn["EKPMEO"] = " ".PadRight(0 ); 
         dwReturn["EKPMEU"] = " ".PadRight(0 ); 
         dwReturn["EKPSMENGE"] = " ".PadRight(0 ); 
         dwReturn["EKPWE1"] = " ".PadRight(0 ); 
         dwReturn["EKPWE2"] = " ".PadRight(0 ); 
         dwReturn["EKPWE3"] = " ".PadRight(0 ); 
         dwReturn["EKPWE4"] = " ".PadRight(0 ); 
         dwReturn["EKPWE5"] = " ".PadRight(0 ); 
         dwReturn["EKPWE6"] = " ".PadRight(0 ); 
         dwReturn["EKPWE7"] = " ".PadRight(0 ); 
         dwReturn["EKPWE8"] = " ".PadRight(0 ); 
         dwReturn["EKPWE9"] = " ".PadRight(0 ); 
         dwReturn["EKPBDAT"] = " ".PadRight(0 ); 
         dwReturn["EKPLTERM"] = " ".PadRight(0 ); 
         dwReturn["EKPFIX"] = " ".PadRight(1 ); 
         dwReturn["EKPLDAT"] = " ".PadRight(8 ); 
         dwReturn["EKPDRUDAT"] = " ".PadRight(0 ); 
         dwReturn["EKPWVTERM"] = " ".PadRight(0 ); 
         dwReturn["EKPWUTERM"] = " ".PadRight(0 ); 
         dwReturn["EKPVEINDAT"] = " ".PadRight(0 ); 
         dwReturn["EKPVEINDALT"] = " ".PadRight(0 ); 
         dwReturn["EKPLTERMBE"] = " ".PadRight(0 ); 
         dwReturn["EKPLTERMKZ"] = " ".PadRight(1 ); 
         dwReturn["EKPVTERMIN"] = " ".PadRight(0 ); 
         dwReturn["EKPVTERMEIN"] = " ".PadRight(8 ); 
         dwReturn["EKPDATVON"] = " ".PadRight(0 ); 
         dwReturn["EKPBEDAT"] = " ".PadRight(0 ); 
         dwReturn["EKPTERMTAB"] = " ".PadRight(4 ); 
         dwReturn["EKPTERMIND"] = " ".PadRight(0 ); 
         dwReturn["EKPSOLLDAT1"] = " ".PadRight(0 ); 
         dwReturn["EKPISTDAT1"] = " ".PadRight(0 ); 
         dwReturn["EKPSOLLDAT2"] = " ".PadRight(0 ); 
         dwReturn["EKPISTDAT2"] = " ".PadRight(0 ); 
         dwReturn["EKPSOLLDAT3"] = " ".PadRight(0 ); 
         dwReturn["EKPISTDAT3"] = " ".PadRight(0 ); 
         dwReturn["EKPSOLLDAT4"] = " ".PadRight(0 ); 
         dwReturn["EKPISTDAT4"] = " ".PadRight(0 ); 
         dwReturn["EKPSOLLDAT5"] = " ".PadRight(0 ); 
         dwReturn["EKPISTDAT5"] = " ".PadRight(0 ); 
         dwReturn["EKPSOLLDAT6"] = " ".PadRight(0 ); 
         dwReturn["EKPISTDAT6"] = " ".PadRight(0 ); 
         dwReturn["EKPLRUECK"] = " ".PadRight(0 ); 
         dwReturn["EKPPRME"] = " ".PadRight(10 ); 
         dwReturn["EKPPREH"] = " ".PadRight(3 ); 
         dwReturn["EKPPREHGRP"] = " ".PadRight(1 ); 
         dwReturn["EKPPREHFKT"] = " ".PadRight(12 ); 
         dwReturn["EKPPRDR"] = " ".PadRight(1 ); 
         dwReturn["EKPPREISKZ"] = " ".PadRight(2 ); 
         dwReturn["EKPPREISLST"] = " ".PadRight(5 ); 
         dwReturn["EKPRABATTKZ"] = " ".PadRight(1 ); 
         dwReturn["EKPRABATT"] = " ".PadRight(0 ); 
         dwReturn["EKPRABART1"] = " ".PadRight(3 ); 
         dwReturn["EKPRABPROZ1"] = " ".PadRight(0 ); 
         dwReturn["EKPRABWERT1"] = " ".PadRight(0 ); 
         dwReturn["EKPRABART2"] = " ".PadRight(3 ); 
         dwReturn["EKPRABPROZ2"] = " ".PadRight(0 ); 
         dwReturn["EKPRABWERT2"] = " ".PadRight(0 ); 
         dwReturn["EKPRABART3"] = " ".PadRight(3 ); 
         dwReturn["EKPRABPROZ3"] = " ".PadRight(0 ); 
         dwReturn["EKPRABWERT3"] = " ".PadRight(0 ); 
         dwReturn["EKPRABART4"] = " ".PadRight(3 ); 
         dwReturn["EKPRABPROZ4"] = " ".PadRight(0 ); 
         dwReturn["EKPRABWERT4"] = " ".PadRight(0 ); 
         dwReturn["EKPRABART5"] = " ".PadRight(3 ); 
         dwReturn["EKPRABPROZ5"] = " ".PadRight(0 ); 
         dwReturn["EKPRABWERT5"] = " ".PadRight(0 ); 
         dwReturn["EKPZUABWERT"] = " ".PadRight(0 ); 
         dwReturn["EKPFIXBONP"] = " ".PadRight(0 ); 
         dwReturn["EKPFIXBONA"] = " ".PadRight(0 ); 
         dwReturn["EKPKALBONP"] = " ".PadRight(0 ); 
         dwReturn["EKPKALBONA"] = " ".PadRight(0 ); 
         dwReturn["EKPCOUPON"] = " ".PadRight(1 ); 
         dwReturn["EKPKOKRS"] = " ".PadRight(2 ); 
         dwReturn["EKPKOLFD"] = " ".PadRight(6 ); 
         dwReturn["EKPKOPOS"] = " ".PadRight(3 ); 
         dwReturn["EKPSTA"] = " ".PadRight(2 ); 
         dwReturn["EKPSTAKZ"] = " ".PadRight(1 ); 
         dwReturn["EKPMAHNKZ"] = " ".PadRight(2 ); 
         dwReturn["EKPMAHNKZA"] = " ".PadRight(2 ); 
         dwReturn["EKPMAHNDAT"] = " ".PadRight(0 ); 
         dwReturn["EKPKTOKL4"] = " ".PadRight(6 ); 
         dwReturn["EKPKSTKRS"] = " ".PadRight(2 ); 
         dwReturn["EKPKST"] = " ".PadRight(4 ); 
         dwReturn["EKPBUDGET"] = " ".PadRight(8 ); 
         dwReturn["EKPINVAUF"] = " ".PadRight(8 ); 
         dwReturn["EKPFAUFTYP"] = " ".PadRight(1 ); 
         dwReturn["EKPFAUFKRS"] = " ".PadRight(2 ); 
         dwReturn["EKPFAUFLFD"] = " ".PadRight(6 ); 
         dwReturn["EKPFAUFPOS"] = " ".PadRight(3 ); 
         dwReturn["EKPANRKR"] = " ".PadRight(2 ); 
         dwReturn["EKPALFDNR"] = " ".PadRight(6 ); 
         dwReturn["EKPWAEHRSL"] = " ".PadRight(3 ); 
         dwReturn["EKPKURS"] = " ".PadRight(0 ); 
         dwReturn["EKPBETRAG"] = " ".PadRight(0 ); 
         dwReturn["EKPHWAEHRSL"] = " ".PadRight(3 ); 
         dwReturn["EKPHEUROKURS"] = " ".PadRight(0 ); 
         dwReturn["EKPHEUROKURSVK"] = " ".PadRight(1 ); 
         dwReturn["EKPFEUROKURS"] = " ".PadRight(0 ); 
         dwReturn["EKPFEUROKURSVK"] = " ".PadRight(1 ); 
         dwReturn["EKPTERMNR"] = " ".PadRight(0 ); 
         dwReturn["EKPFAELLIG"] = " ".PadRight(0 ); 
         dwReturn["EKPSICHER"] = " ".PadRight(1 ); 
         dwReturn["EKPSICHP"] = " ".PadRight(0 ); 
         dwReturn["EKPAKKRED"] = " ".PadRight(15 ); 
         dwReturn["EKPUDATUM"] = " ".PadRight(0 ); 
         dwReturn["EKPUAENZL"] = " ".PadRight(0 ); 
         dwReturn["EKPUAENB"] = " ".PadRight(8 ); 
         dwReturn["EKPLIEFNR"] = " ".PadRight(8 ); 
         dwReturn["EKPKONDSL"] = " ".PadRight(4 ); 
         dwReturn["EKPLO"] = " ".PadRight(2 ); 
         dwReturn["EKPLB"] = " ".PadRight(2 ); 
         dwReturn["EKPFILLER14"] = " ".PadRight(72 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapICC_EKPOS(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveICC_EKPOS(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryICC_EKPOS(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapICC_EKPOS(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertICC_EKPOS(dwLocal, ITXDBVERSION);
            }
            UpdateICC_EKPOS(dwLocal);
        }
        public void InsertICC_EKPOS(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO ICC_EKPOS(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryICC_EKPOS(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM ICC_EKPOS WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM ICC_EKPOS  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "ICC_EKPOS";
            Return = Result;
            return Return;
        }
        public void DeleteICC_EKPOS(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM ICC_EKPOS   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateICC_EKPOS(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE ICC_EKPOS SET "
                    +"EKPAID= :EKPAID,"
                    +"EKKBUCHKRS= :EKKBUCHKRS,"
                    +"EKPMANDANT= :EKPMANDANT,"
                    +"EKPAUFKRS= :EKPAUFKRS,"
                    +"EKPAUFLFD= :EKPAUFLFD,"
                    +"EKPAUFPOS= :EKPAUFPOS,"
                    +"EKPQTYLOCKED= :EKPQTYLOCKED,"
                    +"EKPQTYFREE= :EKPQTYFREE,"
                    +"EKPAENDST= :EKPAENDST,"
                    +"EKPKNTRNRL= :EKPKNTRNRL,"
                    +"EKPAENZL= :EKPAENZL,"
                    +"EKPAENB= :EKPAENB,"
                    +"EKPAEND= :EKPAEND,"
                    +"EKPBEKZ= :EKPBEKZ,"
                    +"EKPNEUB= :EKPNEUB,"
                    +"EKPNEUD= :EKPNEUD,"
                    +"EKPAUFGRP= :EKPAUFGRP,"
                    +"EKPAUFART= :EKPAUFART,"
                    +"EKPARTGR= :EKPARTGR,"
                    +"EKPKUNDNR= :EKPKUNDNR,"
                    +"EKPWERK= :EKPWERK,"
                    +"EKPABT= :EKPABT,"
                    +"EKPWAKZ= :EKPWAKZ,"
                    +"EKPART= :EKPART,"
                    +"EKPVAR= :EKPVAR,"
                    +"EKPFARBE= :EKPFARBE,"
                    +"EKPDESS= :EKPDESS,"
                    +"EKPCOL= :EKPCOL,"
                    +"EKPBESCH= :EKPBESCH,"
                    +"EKPZUSTAND= :EKPZUSTAND,"
                    +"EKPGROE= :EKPGROE,"
                    +"EKPSCHLIGR= :EKPSCHLIGR,"
                    +"EKPSCHLINR= :EKPSCHLINR,"
                    +"EKPLSART= :EKPLSART,"
                    +"EKPLSVAR= :EKPLSVAR,"
                    +"EKPLSFB= :EKPLSFB,"
                    +"EKPLSDESS= :EKPLSDESS,"
                    +"EKPLSCOL= :EKPLSCOL,"
                    +"EKPLSBE= :EKPLSBE,"
                    +"EKPLSZUSTAND= :EKPLSZUSTAND,"
                    +"EKPLSGROE= :EKPLSGROE,"
                    +"EKPLSGRPBEZ= :EKPLSGRPBEZ,"
                    +"EKPLSARTBEZ= :EKPLSARTBEZ,"
                    +"EKPSTKLGV= :EKPSTKLGV,"
                    +"EKPSTKLGB= :EKPSTKLGB,"
                    +"EKPPRKZ= :EKPPRKZ,"
                    +"EKPPRUEF= :EKPPRUEF,"
                    +"EKPMATKOMPDR= :EKPMATKOMPDR,"
                    +"EKPPARTIE= :EKPPARTIE,"
                    +"EKPSPUL= :EKPSPUL,"
                    +"EKPSPULG= :EKPSPULG,"
                    +"EKPSPULM= :EKPSPULM,"
                    +"EKPVPEINH= :EKPVPEINH,"
                    +"EKPAM= :EKPAM,"
                    +"EKPZUSAM= :EKPZUSAM,"
                    +"EKPHUELSE= :EKPHUELSE,"
                    +"EKPKF= :EKPKF,"
                    +"EKPFDRES= :EKPFDRES,"
                    +"EKPWI= :EKPWI,"
                    +"EKPANZTKB= :EKPANZTKB,"
                    +"EKPLOSGR= :EKPLOSGR,"
                    +"EKPWIRKGEW= :EKPWIRKGEW,"
                    +"EKPVKUNDNR= :EKPVKUNDNR,"
                    +"EKPVWERK= :EKPVWERK,"
                    +"EKPVABT= :EKPVABT,"
                    +"EKPVART= :EKPVART,"
                    +"EKPVVAR= :EKPVVAR,"
                    +"EKPVFARBE= :EKPVFARBE,"
                    +"EKPEKUNDNR= :EKPEKUNDNR,"
                    +"EKPEWERK= :EKPEWERK,"
                    +"EKPEABT= :EKPEABT,"
                    +"EKPEART= :EKPEART,"
                    +"EKPEVAR= :EKPEVAR,"
                    +"EKPEFARBE= :EKPEFARBE,"
                    +"EKPEDESS= :EKPEDESS,"
                    +"EKPECOL= :EKPECOL,"
                    +"EKPEBESCH= :EKPEBESCH,"
                    +"EKPEZUSTAND= :EKPEZUSTAND,"
                    +"EKPEGROE= :EKPEGROE,"
                    +"EKPMINLIME= :EKPMINLIME,"
                    +"EKPMINLISP= :EKPMINLISP,"
                    +"EKPMEEH= :EKPMEEH,"
                    +"EKPMEEHGRP= :EKPMEEHGRP,"
                    +"EKPMEEHFKT= :EKPMEEHFKT,"
                    +"EKPME1= :EKPME1,"
                    +"EKPME2= :EKPME2,"
                    +"EKPME3= :EKPME3,"
                    +"EKPME4= :EKPME4,"
                    +"EKPME5= :EKPME5,"
                    +"EKPME6= :EKPME6,"
                    +"EKPME7= :EKPME7,"
                    +"EKPME8= :EKPME8,"
                    +"EKPME9= :EKPME9,"
                    +"EKPMEO= :EKPMEO,"
                    +"EKPMEU= :EKPMEU,"
                    +"EKPSMENGE= :EKPSMENGE,"
                    +"EKPWE1= :EKPWE1,"
                    +"EKPWE2= :EKPWE2,"
                    +"EKPWE3= :EKPWE3,"
                    +"EKPWE4= :EKPWE4,"
                    +"EKPWE5= :EKPWE5,"
                    +"EKPWE6= :EKPWE6,"
                    +"EKPWE7= :EKPWE7,"
                    +"EKPWE8= :EKPWE8,"
                    +"EKPWE9= :EKPWE9,"
                    +"EKPBDAT= :EKPBDAT,"
                    +"EKPLTERM= :EKPLTERM,"
                    +"EKPFIX= :EKPFIX,"
                    +"EKPLDAT= :EKPLDAT,"
                    +"EKPDRUDAT= :EKPDRUDAT,"
                    +"EKPWVTERM= :EKPWVTERM,"
                    +"EKPWUTERM= :EKPWUTERM,"
                    +"EKPVEINDAT= :EKPVEINDAT,"
                    +"EKPVEINDALT= :EKPVEINDALT,"
                    +"EKPLTERMBE= :EKPLTERMBE,"
                    +"EKPLTERMKZ= :EKPLTERMKZ,"
                    +"EKPVTERMIN= :EKPVTERMIN,"
                    +"EKPVTERMEIN= :EKPVTERMEIN,"
                    +"EKPDATVON= :EKPDATVON,"
                    +"EKPBEDAT= :EKPBEDAT,"
                    +"EKPTERMTAB= :EKPTERMTAB,"
                    +"EKPTERMIND= :EKPTERMIND,"
                    +"EKPSOLLDAT1= :EKPSOLLDAT1,"
                    +"EKPISTDAT1= :EKPISTDAT1,"
                    +"EKPSOLLDAT2= :EKPSOLLDAT2,"
                    +"EKPISTDAT2= :EKPISTDAT2,"
                    +"EKPSOLLDAT3= :EKPSOLLDAT3,"
                    +"EKPISTDAT3= :EKPISTDAT3,"
                    +"EKPSOLLDAT4= :EKPSOLLDAT4,"
                    +"EKPISTDAT4= :EKPISTDAT4,"
                    +"EKPSOLLDAT5= :EKPSOLLDAT5,"
                    +"EKPISTDAT5= :EKPISTDAT5,"
                    +"EKPSOLLDAT6= :EKPSOLLDAT6,"
                    +"EKPISTDAT6= :EKPISTDAT6,"
                    +"EKPLRUECK= :EKPLRUECK,"
                    +"EKPPRME= :EKPPRME,"
                    +"EKPPREH= :EKPPREH,"
                    +"EKPPREHGRP= :EKPPREHGRP,"
                    +"EKPPREHFKT= :EKPPREHFKT,"
                    +"EKPPRDR= :EKPPRDR,"
                    +"EKPPREISKZ= :EKPPREISKZ,"
                    +"EKPPREISLST= :EKPPREISLST,"
                    +"EKPRABATTKZ= :EKPRABATTKZ,"
                    +"EKPRABATT= :EKPRABATT,"
                    +"EKPRABART1= :EKPRABART1,"
                    +"EKPRABPROZ1= :EKPRABPROZ1,"
                    +"EKPRABWERT1= :EKPRABWERT1,"
                    +"EKPRABART2= :EKPRABART2,"
                    +"EKPRABPROZ2= :EKPRABPROZ2,"
                    +"EKPRABWERT2= :EKPRABWERT2,"
                    +"EKPRABART3= :EKPRABART3,"
                    +"EKPRABPROZ3= :EKPRABPROZ3,"
                    +"EKPRABWERT3= :EKPRABWERT3,"
                    +"EKPRABART4= :EKPRABART4,"
                    +"EKPRABPROZ4= :EKPRABPROZ4,"
                    +"EKPRABWERT4= :EKPRABWERT4,"
                    +"EKPRABART5= :EKPRABART5,"
                    +"EKPRABPROZ5= :EKPRABPROZ5,"
                    +"EKPRABWERT5= :EKPRABWERT5,"
                    +"EKPZUABWERT= :EKPZUABWERT,"
                    +"EKPFIXBONP= :EKPFIXBONP,"
                    +"EKPFIXBONA= :EKPFIXBONA,"
                    +"EKPKALBONP= :EKPKALBONP,"
                    +"EKPKALBONA= :EKPKALBONA,"
                    +"EKPCOUPON= :EKPCOUPON,"
                    +"EKPKOKRS= :EKPKOKRS,"
                    +"EKPKOLFD= :EKPKOLFD,"
                    +"EKPKOPOS= :EKPKOPOS,"
                    +"EKPSTA= :EKPSTA,"
                    +"EKPSTAKZ= :EKPSTAKZ,"
                    +"EKPMAHNKZ= :EKPMAHNKZ,"
                    +"EKPMAHNKZA= :EKPMAHNKZA,"
                    +"EKPMAHNDAT= :EKPMAHNDAT,"
                    +"EKPKTOKL4= :EKPKTOKL4,"
                    +"EKPKSTKRS= :EKPKSTKRS,"
                    +"EKPKST= :EKPKST,"
                    +"EKPBUDGET= :EKPBUDGET,"
                    +"EKPINVAUF= :EKPINVAUF,"
                    +"EKPFAUFTYP= :EKPFAUFTYP,"
                    +"EKPFAUFKRS= :EKPFAUFKRS,"
                    +"EKPFAUFLFD= :EKPFAUFLFD,"
                    +"EKPFAUFPOS= :EKPFAUFPOS,"
                    +"EKPANRKR= :EKPANRKR,"
                    +"EKPALFDNR= :EKPALFDNR,"
                    +"EKPWAEHRSL= :EKPWAEHRSL,"
                    +"EKPKURS= :EKPKURS,"
                    +"EKPBETRAG= :EKPBETRAG,"
                    +"EKPHWAEHRSL= :EKPHWAEHRSL,"
                    +"EKPHEUROKURS= :EKPHEUROKURS,"
                    +"EKPHEUROKURSVK= :EKPHEUROKURSVK,"
                    +"EKPFEUROKURS= :EKPFEUROKURS,"
                    +"EKPFEUROKURSVK= :EKPFEUROKURSVK,"
                    +"EKPTERMNR= :EKPTERMNR,"
                    +"EKPFAELLIG= :EKPFAELLIG,"
                    +"EKPSICHER= :EKPSICHER,"
                    +"EKPSICHP= :EKPSICHP,"
                    +"EKPAKKRED= :EKPAKKRED,"
                    +"EKPUDATUM= :EKPUDATUM,"
                    +"EKPUAENZL= :EKPUAENZL,"
                    +"EKPUAENB= :EKPUAENB,"
                    +"EKPLIEFNR= :EKPLIEFNR,"
                    +"EKPKONDSL= :EKPKONDSL,"
                    +"EKPLO= :EKPLO,"
                    +"EKPLB= :EKPLB,"
                    +"EKPFILLER14= :EKPFILLER14,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("EKPAID", OracleType.NVarChar).Value = dwData["EKPAID"].ToString(); 
          or1.Parameters.Add("EKKBUCHKRS", OracleType.NVarChar).Value = dwData["EKKBUCHKRS"].ToString(); 
          or1.Parameters.Add("EKPMANDANT", OracleType.NVarChar).Value = dwData["EKPMANDANT"].ToString(); 
          or1.Parameters.Add("EKPAUFKRS", OracleType.NVarChar).Value = dwData["EKPAUFKRS"].ToString(); 
          or1.Parameters.Add("EKPAUFLFD", OracleType.NVarChar).Value = dwData["EKPAUFLFD"].ToString(); 
          or1.Parameters.Add("EKPAUFPOS", OracleType.NVarChar).Value = dwData["EKPAUFPOS"].ToString(); 
          or1.Parameters.Add("EKPQTYLOCKED", OracleType.NVarChar).Value = dwData["EKPQTYLOCKED"].ToString(); 
          or1.Parameters.Add("EKPQTYFREE", OracleType.NVarChar).Value = dwData["EKPQTYFREE"].ToString(); 
          or1.Parameters.Add("EKPAENDST", OracleType.NVarChar).Value = dwData["EKPAENDST"].ToString(); 
          or1.Parameters.Add("EKPKNTRNRL", OracleType.NVarChar).Value = dwData["EKPKNTRNRL"].ToString(); 
          or1.Parameters.Add("EKPAENZL", OracleType.NVarChar).Value = dwData["EKPAENZL"].ToString(); 
          or1.Parameters.Add("EKPAENB", OracleType.NVarChar).Value = dwData["EKPAENB"].ToString(); 
          or1.Parameters.Add("EKPAEND", OracleType.NVarChar).Value = dwData["EKPAEND"].ToString(); 
          or1.Parameters.Add("EKPBEKZ", OracleType.NVarChar).Value = dwData["EKPBEKZ"].ToString(); 
          or1.Parameters.Add("EKPNEUB", OracleType.NVarChar).Value = dwData["EKPNEUB"].ToString(); 
          or1.Parameters.Add("EKPNEUD", OracleType.NVarChar).Value = dwData["EKPNEUD"].ToString(); 
          or1.Parameters.Add("EKPAUFGRP", OracleType.NVarChar).Value = dwData["EKPAUFGRP"].ToString(); 
          or1.Parameters.Add("EKPAUFART", OracleType.NVarChar).Value = dwData["EKPAUFART"].ToString(); 
          or1.Parameters.Add("EKPARTGR", OracleType.NVarChar).Value = dwData["EKPARTGR"].ToString(); 
          or1.Parameters.Add("EKPKUNDNR", OracleType.NVarChar).Value = dwData["EKPKUNDNR"].ToString(); 
          or1.Parameters.Add("EKPWERK", OracleType.NVarChar).Value = dwData["EKPWERK"].ToString(); 
          or1.Parameters.Add("EKPABT", OracleType.NVarChar).Value = dwData["EKPABT"].ToString(); 
          or1.Parameters.Add("EKPWAKZ", OracleType.NVarChar).Value = dwData["EKPWAKZ"].ToString(); 
          or1.Parameters.Add("EKPART", OracleType.NVarChar).Value = dwData["EKPART"].ToString(); 
          or1.Parameters.Add("EKPVAR", OracleType.NVarChar).Value = dwData["EKPVAR"].ToString(); 
          or1.Parameters.Add("EKPFARBE", OracleType.NVarChar).Value = dwData["EKPFARBE"].ToString(); 
          or1.Parameters.Add("EKPDESS", OracleType.NVarChar).Value = dwData["EKPDESS"].ToString(); 
          or1.Parameters.Add("EKPCOL", OracleType.NVarChar).Value = dwData["EKPCOL"].ToString(); 
          or1.Parameters.Add("EKPBESCH", OracleType.NVarChar).Value = dwData["EKPBESCH"].ToString(); 
          or1.Parameters.Add("EKPZUSTAND", OracleType.NVarChar).Value = dwData["EKPZUSTAND"].ToString(); 
          or1.Parameters.Add("EKPGROE", OracleType.NVarChar).Value = dwData["EKPGROE"].ToString(); 
          or1.Parameters.Add("EKPSCHLIGR", OracleType.NVarChar).Value = dwData["EKPSCHLIGR"].ToString(); 
          or1.Parameters.Add("EKPSCHLINR", OracleType.NVarChar).Value = dwData["EKPSCHLINR"].ToString(); 
          or1.Parameters.Add("EKPLSART", OracleType.NVarChar).Value = dwData["EKPLSART"].ToString(); 
          or1.Parameters.Add("EKPLSVAR", OracleType.NVarChar).Value = dwData["EKPLSVAR"].ToString(); 
          or1.Parameters.Add("EKPLSFB", OracleType.NVarChar).Value = dwData["EKPLSFB"].ToString(); 
          or1.Parameters.Add("EKPLSDESS", OracleType.NVarChar).Value = dwData["EKPLSDESS"].ToString(); 
          or1.Parameters.Add("EKPLSCOL", OracleType.NVarChar).Value = dwData["EKPLSCOL"].ToString(); 
          or1.Parameters.Add("EKPLSBE", OracleType.NVarChar).Value = dwData["EKPLSBE"].ToString(); 
          or1.Parameters.Add("EKPLSZUSTAND", OracleType.NVarChar).Value = dwData["EKPLSZUSTAND"].ToString(); 
          or1.Parameters.Add("EKPLSGROE", OracleType.NVarChar).Value = dwData["EKPLSGROE"].ToString(); 
          or1.Parameters.Add("EKPLSGRPBEZ", OracleType.NVarChar).Value = dwData["EKPLSGRPBEZ"].ToString(); 
          or1.Parameters.Add("EKPLSARTBEZ", OracleType.NVarChar).Value = dwData["EKPLSARTBEZ"].ToString(); 
          or1.Parameters.Add("EKPSTKLGV", OracleType.NVarChar).Value = dwData["EKPSTKLGV"].ToString(); 
          or1.Parameters.Add("EKPSTKLGB", OracleType.NVarChar).Value = dwData["EKPSTKLGB"].ToString(); 
          or1.Parameters.Add("EKPPRKZ", OracleType.NVarChar).Value = dwData["EKPPRKZ"].ToString(); 
          or1.Parameters.Add("EKPPRUEF", OracleType.NVarChar).Value = dwData["EKPPRUEF"].ToString(); 
          or1.Parameters.Add("EKPMATKOMPDR", OracleType.NVarChar).Value = dwData["EKPMATKOMPDR"].ToString(); 
          or1.Parameters.Add("EKPPARTIE", OracleType.NVarChar).Value = dwData["EKPPARTIE"].ToString(); 
          or1.Parameters.Add("EKPSPUL", OracleType.NVarChar).Value = dwData["EKPSPUL"].ToString(); 
          or1.Parameters.Add("EKPSPULG", OracleType.NVarChar).Value = dwData["EKPSPULG"].ToString(); 
          or1.Parameters.Add("EKPSPULM", OracleType.NVarChar).Value = dwData["EKPSPULM"].ToString(); 
          or1.Parameters.Add("EKPVPEINH", OracleType.NVarChar).Value = dwData["EKPVPEINH"].ToString(); 
          or1.Parameters.Add("EKPAM", OracleType.NVarChar).Value = dwData["EKPAM"].ToString(); 
          or1.Parameters.Add("EKPZUSAM", OracleType.NVarChar).Value = dwData["EKPZUSAM"].ToString(); 
          or1.Parameters.Add("EKPHUELSE", OracleType.NVarChar).Value = dwData["EKPHUELSE"].ToString(); 
          or1.Parameters.Add("EKPKF", OracleType.NVarChar).Value = dwData["EKPKF"].ToString(); 
          or1.Parameters.Add("EKPFDRES", OracleType.NVarChar).Value = dwData["EKPFDRES"].ToString(); 
          or1.Parameters.Add("EKPWI", OracleType.NVarChar).Value = dwData["EKPWI"].ToString(); 
          or1.Parameters.Add("EKPANZTKB", OracleType.NVarChar).Value = dwData["EKPANZTKB"].ToString(); 
          or1.Parameters.Add("EKPLOSGR", OracleType.NVarChar).Value = dwData["EKPLOSGR"].ToString(); 
          or1.Parameters.Add("EKPWIRKGEW", OracleType.NVarChar).Value = dwData["EKPWIRKGEW"].ToString(); 
          or1.Parameters.Add("EKPVKUNDNR", OracleType.NVarChar).Value = dwData["EKPVKUNDNR"].ToString(); 
          or1.Parameters.Add("EKPVWERK", OracleType.NVarChar).Value = dwData["EKPVWERK"].ToString(); 
          or1.Parameters.Add("EKPVABT", OracleType.NVarChar).Value = dwData["EKPVABT"].ToString(); 
          or1.Parameters.Add("EKPVART", OracleType.NVarChar).Value = dwData["EKPVART"].ToString(); 
          or1.Parameters.Add("EKPVVAR", OracleType.NVarChar).Value = dwData["EKPVVAR"].ToString(); 
          or1.Parameters.Add("EKPVFARBE", OracleType.NVarChar).Value = dwData["EKPVFARBE"].ToString(); 
          or1.Parameters.Add("EKPEKUNDNR", OracleType.NVarChar).Value = dwData["EKPEKUNDNR"].ToString(); 
          or1.Parameters.Add("EKPEWERK", OracleType.NVarChar).Value = dwData["EKPEWERK"].ToString(); 
          or1.Parameters.Add("EKPEABT", OracleType.NVarChar).Value = dwData["EKPEABT"].ToString(); 
          or1.Parameters.Add("EKPEART", OracleType.NVarChar).Value = dwData["EKPEART"].ToString(); 
          or1.Parameters.Add("EKPEVAR", OracleType.NVarChar).Value = dwData["EKPEVAR"].ToString(); 
          or1.Parameters.Add("EKPEFARBE", OracleType.NVarChar).Value = dwData["EKPEFARBE"].ToString(); 
          or1.Parameters.Add("EKPEDESS", OracleType.NVarChar).Value = dwData["EKPEDESS"].ToString(); 
          or1.Parameters.Add("EKPECOL", OracleType.NVarChar).Value = dwData["EKPECOL"].ToString(); 
          or1.Parameters.Add("EKPEBESCH", OracleType.NVarChar).Value = dwData["EKPEBESCH"].ToString(); 
          or1.Parameters.Add("EKPEZUSTAND", OracleType.NVarChar).Value = dwData["EKPEZUSTAND"].ToString(); 
          or1.Parameters.Add("EKPEGROE", OracleType.NVarChar).Value = dwData["EKPEGROE"].ToString(); 
          or1.Parameters.Add("EKPMINLIME", OracleType.NVarChar).Value = dwData["EKPMINLIME"].ToString(); 
          or1.Parameters.Add("EKPMINLISP", OracleType.NVarChar).Value = dwData["EKPMINLISP"].ToString(); 
          or1.Parameters.Add("EKPMEEH", OracleType.NVarChar).Value = dwData["EKPMEEH"].ToString(); 
          or1.Parameters.Add("EKPMEEHGRP", OracleType.NVarChar).Value = dwData["EKPMEEHGRP"].ToString(); 
          or1.Parameters.Add("EKPMEEHFKT", OracleType.NVarChar).Value = dwData["EKPMEEHFKT"].ToString(); 
          or1.Parameters.Add("EKPME1", OracleType.NVarChar).Value = dwData["EKPME1"].ToString(); 
          or1.Parameters.Add("EKPME2", OracleType.NVarChar).Value = dwData["EKPME2"].ToString(); 
          or1.Parameters.Add("EKPME3", OracleType.NVarChar).Value = dwData["EKPME3"].ToString(); 
          or1.Parameters.Add("EKPME4", OracleType.NVarChar).Value = dwData["EKPME4"].ToString(); 
          or1.Parameters.Add("EKPME5", OracleType.NVarChar).Value = dwData["EKPME5"].ToString(); 
          or1.Parameters.Add("EKPME6", OracleType.NVarChar).Value = dwData["EKPME6"].ToString(); 
          or1.Parameters.Add("EKPME7", OracleType.NVarChar).Value = dwData["EKPME7"].ToString(); 
          or1.Parameters.Add("EKPME8", OracleType.NVarChar).Value = dwData["EKPME8"].ToString(); 
          or1.Parameters.Add("EKPME9", OracleType.NVarChar).Value = dwData["EKPME9"].ToString(); 
          or1.Parameters.Add("EKPMEO", OracleType.NVarChar).Value = dwData["EKPMEO"].ToString(); 
          or1.Parameters.Add("EKPMEU", OracleType.NVarChar).Value = dwData["EKPMEU"].ToString(); 
          or1.Parameters.Add("EKPSMENGE", OracleType.NVarChar).Value = dwData["EKPSMENGE"].ToString(); 
          or1.Parameters.Add("EKPWE1", OracleType.NVarChar).Value = dwData["EKPWE1"].ToString(); 
          or1.Parameters.Add("EKPWE2", OracleType.NVarChar).Value = dwData["EKPWE2"].ToString(); 
          or1.Parameters.Add("EKPWE3", OracleType.NVarChar).Value = dwData["EKPWE3"].ToString(); 
          or1.Parameters.Add("EKPWE4", OracleType.NVarChar).Value = dwData["EKPWE4"].ToString(); 
          or1.Parameters.Add("EKPWE5", OracleType.NVarChar).Value = dwData["EKPWE5"].ToString(); 
          or1.Parameters.Add("EKPWE6", OracleType.NVarChar).Value = dwData["EKPWE6"].ToString(); 
          or1.Parameters.Add("EKPWE7", OracleType.NVarChar).Value = dwData["EKPWE7"].ToString(); 
          or1.Parameters.Add("EKPWE8", OracleType.NVarChar).Value = dwData["EKPWE8"].ToString(); 
          or1.Parameters.Add("EKPWE9", OracleType.NVarChar).Value = dwData["EKPWE9"].ToString(); 
          or1.Parameters.Add("EKPBDAT", OracleType.NVarChar).Value = dwData["EKPBDAT"].ToString(); 
          or1.Parameters.Add("EKPLTERM", OracleType.NVarChar).Value = dwData["EKPLTERM"].ToString(); 
          or1.Parameters.Add("EKPFIX", OracleType.NVarChar).Value = dwData["EKPFIX"].ToString(); 
          or1.Parameters.Add("EKPLDAT", OracleType.NVarChar).Value = dwData["EKPLDAT"].ToString(); 
          or1.Parameters.Add("EKPDRUDAT", OracleType.NVarChar).Value = dwData["EKPDRUDAT"].ToString(); 
          or1.Parameters.Add("EKPWVTERM", OracleType.NVarChar).Value = dwData["EKPWVTERM"].ToString(); 
          or1.Parameters.Add("EKPWUTERM", OracleType.NVarChar).Value = dwData["EKPWUTERM"].ToString(); 
          or1.Parameters.Add("EKPVEINDAT", OracleType.NVarChar).Value = dwData["EKPVEINDAT"].ToString(); 
          or1.Parameters.Add("EKPVEINDALT", OracleType.NVarChar).Value = dwData["EKPVEINDALT"].ToString(); 
          or1.Parameters.Add("EKPLTERMBE", OracleType.NVarChar).Value = dwData["EKPLTERMBE"].ToString(); 
          or1.Parameters.Add("EKPLTERMKZ", OracleType.NVarChar).Value = dwData["EKPLTERMKZ"].ToString(); 
          or1.Parameters.Add("EKPVTERMIN", OracleType.NVarChar).Value = dwData["EKPVTERMIN"].ToString(); 
          or1.Parameters.Add("EKPVTERMEIN", OracleType.NVarChar).Value = dwData["EKPVTERMEIN"].ToString(); 
          or1.Parameters.Add("EKPDATVON", OracleType.NVarChar).Value = dwData["EKPDATVON"].ToString(); 
          or1.Parameters.Add("EKPBEDAT", OracleType.NVarChar).Value = dwData["EKPBEDAT"].ToString(); 
          or1.Parameters.Add("EKPTERMTAB", OracleType.NVarChar).Value = dwData["EKPTERMTAB"].ToString(); 
          or1.Parameters.Add("EKPTERMIND", OracleType.NVarChar).Value = dwData["EKPTERMIND"].ToString(); 
          or1.Parameters.Add("EKPSOLLDAT1", OracleType.NVarChar).Value = dwData["EKPSOLLDAT1"].ToString(); 
          or1.Parameters.Add("EKPISTDAT1", OracleType.NVarChar).Value = dwData["EKPISTDAT1"].ToString(); 
          or1.Parameters.Add("EKPSOLLDAT2", OracleType.NVarChar).Value = dwData["EKPSOLLDAT2"].ToString(); 
          or1.Parameters.Add("EKPISTDAT2", OracleType.NVarChar).Value = dwData["EKPISTDAT2"].ToString(); 
          or1.Parameters.Add("EKPSOLLDAT3", OracleType.NVarChar).Value = dwData["EKPSOLLDAT3"].ToString(); 
          or1.Parameters.Add("EKPISTDAT3", OracleType.NVarChar).Value = dwData["EKPISTDAT3"].ToString(); 
          or1.Parameters.Add("EKPSOLLDAT4", OracleType.NVarChar).Value = dwData["EKPSOLLDAT4"].ToString(); 
          or1.Parameters.Add("EKPISTDAT4", OracleType.NVarChar).Value = dwData["EKPISTDAT4"].ToString(); 
          or1.Parameters.Add("EKPSOLLDAT5", OracleType.NVarChar).Value = dwData["EKPSOLLDAT5"].ToString(); 
          or1.Parameters.Add("EKPISTDAT5", OracleType.NVarChar).Value = dwData["EKPISTDAT5"].ToString(); 
          or1.Parameters.Add("EKPSOLLDAT6", OracleType.NVarChar).Value = dwData["EKPSOLLDAT6"].ToString(); 
          or1.Parameters.Add("EKPISTDAT6", OracleType.NVarChar).Value = dwData["EKPISTDAT6"].ToString(); 
          or1.Parameters.Add("EKPLRUECK", OracleType.NVarChar).Value = dwData["EKPLRUECK"].ToString(); 
          or1.Parameters.Add("EKPPRME", OracleType.NVarChar).Value = dwData["EKPPRME"].ToString(); 
          or1.Parameters.Add("EKPPREH", OracleType.NVarChar).Value = dwData["EKPPREH"].ToString(); 
          or1.Parameters.Add("EKPPREHGRP", OracleType.NVarChar).Value = dwData["EKPPREHGRP"].ToString(); 
          or1.Parameters.Add("EKPPREHFKT", OracleType.NVarChar).Value = dwData["EKPPREHFKT"].ToString(); 
          or1.Parameters.Add("EKPPRDR", OracleType.NVarChar).Value = dwData["EKPPRDR"].ToString(); 
          or1.Parameters.Add("EKPPREISKZ", OracleType.NVarChar).Value = dwData["EKPPREISKZ"].ToString(); 
          or1.Parameters.Add("EKPPREISLST", OracleType.NVarChar).Value = dwData["EKPPREISLST"].ToString(); 
          or1.Parameters.Add("EKPRABATTKZ", OracleType.NVarChar).Value = dwData["EKPRABATTKZ"].ToString(); 
          or1.Parameters.Add("EKPRABATT", OracleType.NVarChar).Value = dwData["EKPRABATT"].ToString(); 
          or1.Parameters.Add("EKPRABART1", OracleType.NVarChar).Value = dwData["EKPRABART1"].ToString(); 
          or1.Parameters.Add("EKPRABPROZ1", OracleType.NVarChar).Value = dwData["EKPRABPROZ1"].ToString(); 
          or1.Parameters.Add("EKPRABWERT1", OracleType.NVarChar).Value = dwData["EKPRABWERT1"].ToString(); 
          or1.Parameters.Add("EKPRABART2", OracleType.NVarChar).Value = dwData["EKPRABART2"].ToString(); 
          or1.Parameters.Add("EKPRABPROZ2", OracleType.NVarChar).Value = dwData["EKPRABPROZ2"].ToString(); 
          or1.Parameters.Add("EKPRABWERT2", OracleType.NVarChar).Value = dwData["EKPRABWERT2"].ToString(); 
          or1.Parameters.Add("EKPRABART3", OracleType.NVarChar).Value = dwData["EKPRABART3"].ToString(); 
          or1.Parameters.Add("EKPRABPROZ3", OracleType.NVarChar).Value = dwData["EKPRABPROZ3"].ToString(); 
          or1.Parameters.Add("EKPRABWERT3", OracleType.NVarChar).Value = dwData["EKPRABWERT3"].ToString(); 
          or1.Parameters.Add("EKPRABART4", OracleType.NVarChar).Value = dwData["EKPRABART4"].ToString(); 
          or1.Parameters.Add("EKPRABPROZ4", OracleType.NVarChar).Value = dwData["EKPRABPROZ4"].ToString(); 
          or1.Parameters.Add("EKPRABWERT4", OracleType.NVarChar).Value = dwData["EKPRABWERT4"].ToString(); 
          or1.Parameters.Add("EKPRABART5", OracleType.NVarChar).Value = dwData["EKPRABART5"].ToString(); 
          or1.Parameters.Add("EKPRABPROZ5", OracleType.NVarChar).Value = dwData["EKPRABPROZ5"].ToString(); 
          or1.Parameters.Add("EKPRABWERT5", OracleType.NVarChar).Value = dwData["EKPRABWERT5"].ToString(); 
          or1.Parameters.Add("EKPZUABWERT", OracleType.NVarChar).Value = dwData["EKPZUABWERT"].ToString(); 
          or1.Parameters.Add("EKPFIXBONP", OracleType.NVarChar).Value = dwData["EKPFIXBONP"].ToString(); 
          or1.Parameters.Add("EKPFIXBONA", OracleType.NVarChar).Value = dwData["EKPFIXBONA"].ToString(); 
          or1.Parameters.Add("EKPKALBONP", OracleType.NVarChar).Value = dwData["EKPKALBONP"].ToString(); 
          or1.Parameters.Add("EKPKALBONA", OracleType.NVarChar).Value = dwData["EKPKALBONA"].ToString(); 
          or1.Parameters.Add("EKPCOUPON", OracleType.NVarChar).Value = dwData["EKPCOUPON"].ToString(); 
          or1.Parameters.Add("EKPKOKRS", OracleType.NVarChar).Value = dwData["EKPKOKRS"].ToString(); 
          or1.Parameters.Add("EKPKOLFD", OracleType.NVarChar).Value = dwData["EKPKOLFD"].ToString(); 
          or1.Parameters.Add("EKPKOPOS", OracleType.NVarChar).Value = dwData["EKPKOPOS"].ToString(); 
          or1.Parameters.Add("EKPSTA", OracleType.NVarChar).Value = dwData["EKPSTA"].ToString(); 
          or1.Parameters.Add("EKPSTAKZ", OracleType.NVarChar).Value = dwData["EKPSTAKZ"].ToString(); 
          or1.Parameters.Add("EKPMAHNKZ", OracleType.NVarChar).Value = dwData["EKPMAHNKZ"].ToString(); 
          or1.Parameters.Add("EKPMAHNKZA", OracleType.NVarChar).Value = dwData["EKPMAHNKZA"].ToString(); 
          or1.Parameters.Add("EKPMAHNDAT", OracleType.NVarChar).Value = dwData["EKPMAHNDAT"].ToString(); 
          or1.Parameters.Add("EKPKTOKL4", OracleType.NVarChar).Value = dwData["EKPKTOKL4"].ToString(); 
          or1.Parameters.Add("EKPKSTKRS", OracleType.NVarChar).Value = dwData["EKPKSTKRS"].ToString(); 
          or1.Parameters.Add("EKPKST", OracleType.NVarChar).Value = dwData["EKPKST"].ToString(); 
          or1.Parameters.Add("EKPBUDGET", OracleType.NVarChar).Value = dwData["EKPBUDGET"].ToString(); 
          or1.Parameters.Add("EKPINVAUF", OracleType.NVarChar).Value = dwData["EKPINVAUF"].ToString(); 
          or1.Parameters.Add("EKPFAUFTYP", OracleType.NVarChar).Value = dwData["EKPFAUFTYP"].ToString(); 
          or1.Parameters.Add("EKPFAUFKRS", OracleType.NVarChar).Value = dwData["EKPFAUFKRS"].ToString(); 
          or1.Parameters.Add("EKPFAUFLFD", OracleType.NVarChar).Value = dwData["EKPFAUFLFD"].ToString(); 
          or1.Parameters.Add("EKPFAUFPOS", OracleType.NVarChar).Value = dwData["EKPFAUFPOS"].ToString(); 
          or1.Parameters.Add("EKPANRKR", OracleType.NVarChar).Value = dwData["EKPANRKR"].ToString(); 
          or1.Parameters.Add("EKPALFDNR", OracleType.NVarChar).Value = dwData["EKPALFDNR"].ToString(); 
          or1.Parameters.Add("EKPWAEHRSL", OracleType.NVarChar).Value = dwData["EKPWAEHRSL"].ToString(); 
          or1.Parameters.Add("EKPKURS", OracleType.NVarChar).Value = dwData["EKPKURS"].ToString(); 
          or1.Parameters.Add("EKPBETRAG", OracleType.NVarChar).Value = dwData["EKPBETRAG"].ToString(); 
          or1.Parameters.Add("EKPHWAEHRSL", OracleType.NVarChar).Value = dwData["EKPHWAEHRSL"].ToString(); 
          or1.Parameters.Add("EKPHEUROKURS", OracleType.NVarChar).Value = dwData["EKPHEUROKURS"].ToString(); 
          or1.Parameters.Add("EKPHEUROKURSVK", OracleType.NVarChar).Value = dwData["EKPHEUROKURSVK"].ToString(); 
          or1.Parameters.Add("EKPFEUROKURS", OracleType.NVarChar).Value = dwData["EKPFEUROKURS"].ToString(); 
          or1.Parameters.Add("EKPFEUROKURSVK", OracleType.NVarChar).Value = dwData["EKPFEUROKURSVK"].ToString(); 
          or1.Parameters.Add("EKPTERMNR", OracleType.NVarChar).Value = dwData["EKPTERMNR"].ToString(); 
          or1.Parameters.Add("EKPFAELLIG", OracleType.NVarChar).Value = dwData["EKPFAELLIG"].ToString(); 
          or1.Parameters.Add("EKPSICHER", OracleType.NVarChar).Value = dwData["EKPSICHER"].ToString(); 
          or1.Parameters.Add("EKPSICHP", OracleType.NVarChar).Value = dwData["EKPSICHP"].ToString(); 
          or1.Parameters.Add("EKPAKKRED", OracleType.NVarChar).Value = dwData["EKPAKKRED"].ToString(); 
          or1.Parameters.Add("EKPUDATUM", OracleType.NVarChar).Value = dwData["EKPUDATUM"].ToString(); 
          or1.Parameters.Add("EKPUAENZL", OracleType.NVarChar).Value = dwData["EKPUAENZL"].ToString(); 
          or1.Parameters.Add("EKPUAENB", OracleType.NVarChar).Value = dwData["EKPUAENB"].ToString(); 
          or1.Parameters.Add("EKPLIEFNR", OracleType.NVarChar).Value = dwData["EKPLIEFNR"].ToString(); 
          or1.Parameters.Add("EKPKONDSL", OracleType.NVarChar).Value = dwData["EKPKONDSL"].ToString(); 
          or1.Parameters.Add("EKPLO", OracleType.NVarChar).Value = dwData["EKPLO"].ToString(); 
          or1.Parameters.Add("EKPLB", OracleType.NVarChar).Value = dwData["EKPLB"].ToString(); 
          or1.Parameters.Add("EKPFILLER14", OracleType.NVarChar).Value = dwData["EKPFILLER14"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
